
SELECT ProductID, ProductName, UnitPrice, CategoryID,
       ROW_NUMBER() OVER (ORDER BY UnitPrice DESC) AS Num
FROM Products
WHERE Num <= 3
--------------------------------------------------------------
SELECT ProductID, ProductName, UnitPrice, CategoryID,Num,D
FROM 
(
SELECT ProductID, ProductName, UnitPrice, CategoryID,
       ROW_NUMBER() OVER (ORDER BY UnitPrice DESC) AS Num,
	   DENSE_RANK() OVER (ORDER BY UnitPrice DESC) AS D
FROM Products
) AS T
WHERE D IN (11,12)
